Problem Note 57986: The SAS® 360 Discover ETL job 2000_load_referrer_query_string_dim fails and generates an error
 |  |  |  |  |
In SAS 360 Discover, a failure occurs when you run the extract, transform, and load (ETL) job 2000_load_referrer_query_string_dim. In addition, the following error is generated:
ERROR: CLI execute error: ERROR: invalid byte sequence for encoding "UTF8":
0xd83d; Error while executing the query
As a workaround, modify the cleansing macro in the cxt_clean_ref_query_str_dim.sas file and apply the KPROPDATA function, as shown below:
referrer_query_string_txt=kpropdata(referrer_query_string_text,'trim','utf8');
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Customer Intelligence 360 | N/A | 1.0 | 1.0 | ||
A fix for this issue for SAS Customer Experience Targeting Server 6.4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Y67.html#57986| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2016-05-09 14:14:22 |
| Date Created: | 2016-04-04 08:59:45 |